
<html><HEAD>
<LINK REL=STYLESHEET HREF="default.css" TYPE="text/css">
<TITLE>
Preparing to use the SQL Server database</TITLE>
</HEAD>
<BODY>

<!-- Header -->
<p class="ancestor" align="right"><A HREF="connpbp56.htm">Previous</A>&nbsp;&nbsp;<A HREF="connpbp58.htm" >Next</A>
<!-- End Header -->
<A NAME="CCJDJDDE"></A><h1>Preparing to use the SQL Server database</h1>
<A NAME="TI1079"></A><p>Before you define the database interface and connect to a
Microsoft SQL Server database in PowerBuilder, follow these steps
to prepare the database for use: <A NAME="TI1080"></A>
<ol>
</li>
<li class=ds>Install and configure the required
database server, network, and client software. </li>
<li class=ds>Install the SQL Native Client database interface.</li>
<li class=ds>Verify that you can connect to the Microsoft SQL
Server server and database outside PowerBuilder. 
</li>
</ol>
</p>
<A NAME="TI1081"></A><h4>Step 1: Install and configure the database server</h4>
<A NAME="TI1082"></A><p>You must install and configure the database server, network,
and client software for SQL Server. </p>
<A NAME="TI1083"></A><p><img src="images/proc.gif" width=17 height=17 border=0 align="bottom" alt="Steps"> To install and configure the database server,
network, and client software:</p>
<ol><li class=fi><p>Make sure the Microsoft SQL Server database
software is installed and running on the server specified in your
database profile.</p><p>You must obtain the database server software and required
licenses from Microsoft Corporation. For installation instructions,
see your Microsoft SQL Server documentation.</p><p><img src="images/note.gif" width=17 height=17 border=0 align="bottom" alt="Note"> <span class=shaded>Upgrading from an earlier version of SQL Server</span> <A NAME="TI1084"></A>For instructions on upgrading to a later version of SQL Server
or installing it alongside an earlier version, see your Microsoft
SQL Server documentation.</p>
</li>
<li class=ds><p>If you are accessing a remote SQL Server database,
make sure the required network software (for example, TCP/IP)
is installed and running on your computer and is properly configured
so that you can connect to the SQL Server database server at your
site.</p><p>For installation and configuration instructions,
see your network or database administrator.</p></li>
<li class=ds><p>Install the required Microsoft SQL Native Client
software on each client computer on which PowerBuilder is installed.</p><p>You must obtain the SQL Native Client software from Microsoft.
Make sure the version of the client software you install supports <i>all</i> of
the following:<A NAME="TI1085"></A>
<ul>
<li class=fi>The operating
system running on the client computer</li>
<li class=ds>The version of the database that you want to access</li>
<li class=ds>The version of PowerBuilder that you are running
</li>
</ul>
</p><p>For installation instructions, see your Microsoft
SQL Server documentation.</p></li>
<li class=ds><p>Make sure the SQL Native Client client software
is properly configured so that you can connect to the SQL Server
database server at your site.</p><p>For configuration instructions, see your Microsoft
SQL Server documentation.</p></li>
<li class=ds><p>Make sure the directory containing the SQL Native
Client software is in your system path.</p></li>
<li class=ds><p>Make sure only one copy of the <i>Sqlncli.dll</i> file
is installed on your computer.</p></li></ol>
<br><A NAME="TI1086"></A><h4>Step 2: Install the database interface</h4>
<A NAME="TI1087"></A><p>In the PowerBuilder Setup program, select the Custom install
and select the SQL Native Client database interface.</p>
<A NAME="TI1088"></A><h4>Step 3: Verify the connection </h4>
<A NAME="TI1089"></A><p>Make sure you can connect to the SQL Server server and database
you want to access from outside PowerBuilder.</p>
<A NAME="TI1090"></A><p>To verify the connection, use any Windows-based utility that
connects to the database. When connecting, be sure to specify the
same parameters you plan to use in your PowerBuilder database profile
to access the database.</p>

